﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_AddScope]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_AddScope];
GO
CREATE PROCEDURE [dbo].[sproc_AddScope]
    @FileName nvarchar(300),
    @Path nvarchar(300), 
    @Characterization ntext,
    @Rank int, 
    @Create datetime, 
    @Size int
AS
INSERT INTO uds_scope ([FileName],[Path],[Characterization],[Rank], [Create], [Size])
    VALUES(@FileName,@Path,@Characterization,@Rank,@Create,@Size)